EXCEL IN 7 DAYS by Global Emenwa & IfeanyiChukwu Ejike

Author:Global, Emenwa & IfeanyiChukwu, Ejike
Language: eng
Format: epub, pdf
Published: 2022-02-23T00:00:00+00:00

A8 of the Excel spreadsheet above contains a number/number formula. In the case of A8/B8, the formula produces #DIV/0! Error in cell C8 because cell B8 has 0 value. Column D utilizes the IFERROR function to give 0 as an alternative result when a formula fails. Because A8/B8 results in the #DIV/0, the IFERROR function in cell D8 would produce 0 (the alternate value):

=IFERROR(A3/B3,0) 0 is a result

IFNA

If a formula returns a #N/A error, the IFNA function in Microsoft Excel returns a value to replace it with. The IFNA function is an integral part of Excel and is classified as a Logical Function. If a formula returns the #N/A error code, the IFNA function returns the value specified; otherwise, the formula's result is returned.

Syntax: IFNA(value, value_if_na)

The IFNA function is useful when using functions that may return the #N/A error, such as VLOOKUP, HLOOKUP, or LOOKUP. The IFNA function may return a different result than the #N/A error code in some cases.

The VLOOKUP algorithm in Column F of the Excel spreadsheet above determines the Unit Price for the product name in Column E.

Column G in the screenshot below makes use of the IFNA function to return a value of 0 in the event of a VLOOKUP failure.

Because the VLOOKUP function VLOOKUP(E3,$A$3:$C$7,2, FALSE) produced the #N/A error, the IFNA equation in G3 cell would return 0 (i.e., the alternate value):

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.